{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns\n",
    "%matplotlib inline\n",
    "import warnings\n",
    "warnings.filterwarnings('ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data = pd.DataFrame(\n",
    "                            columns=[\n",
    "                                     #个人id\n",
    "                                     'id',\n",
    "                                     #地区\n",
    "                                     'region_parent',\n",
    "                                     'region_detail',\n",
    "                                     #学校\n",
    "                                     'school_parent',\n",
    "                                     'school_detail',\n",
    "                                     #专业\n",
    "                                     'major_parent',\n",
    "                                     'major_detail',\n",
    "                                     #兴趣\n",
    "                                     'interest_parent',\n",
    "                                     'interest_detail',\n",
    "                                     ]\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['id'] = range(10000,11000)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['region_parent'] = user_data['region_parent'].apply(lambda x : np.random.choice(['四川','重庆'],p=[0.91,0.09]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "四川    906\n",
       "重庆     94\n",
       "Name: region_parent, dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_data['region_parent'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "sichuan = ['成都市','绵阳市','广元市','达州市','南充市','德阳市','广安市','阿坝州','巴中市','遂宁市','内江市','凉山州','攀枝花市','乐山市','自贡市','泸州市','雅安市','宜宾市','资阳市','眉山市']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1.0000000000000004"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "p_value_city = [0.15,0.07,0.05,0.03,0.05,0.06,0.03,0.01,0.02,0.04,0.04,0.01,0.05,0.06,0.07,0.06,0.05,0.07,0.05,0.03]\n",
    "sum(p_value_city)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "for i in range(0,len(user_data)):\n",
    "    if user_data['region_parent'][i] == '四川':\n",
    "        user_data['region_detail'][i] = np.random.choice(sichuan,p=p_value_city)\n",
    "    else:\n",
    "        user_data['region_detail'][i] = '重庆'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "成都市     133\n",
       "重庆       94\n",
       "自贡市      65\n",
       "宜宾市      60\n",
       "泸州市      59\n",
       "德阳市      58\n",
       "绵阳市      58\n",
       "攀枝花市     50\n",
       "南充市      50\n",
       "资阳市      48\n",
       "广元市      48\n",
       "乐山市      46\n",
       "雅安市      42\n",
       "达州市      38\n",
       "内江市      35\n",
       "眉山市      34\n",
       "遂宁市      31\n",
       "广安市      27\n",
       "巴中市      11\n",
       "阿坝州       7\n",
       "凉山州       6\n",
       "Name: region_detail, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_data['region_detail'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "school = ['成都信息工程大学',\n",
    "          '四川大学锦城学院',\n",
    "          '电子科技大学',\n",
    "          '成都理工大学',\n",
    "          '西南石油大学',\n",
    "          '西南交通大学',\n",
    "          '西华大学',\n",
    "          '四川大学',\n",
    "          '四川师范大学',\n",
    "          '西南财经大学',\n",
    "          '西南石油大学']\n",
    "\n",
    "user_data['school_parent'] = user_data['school_parent'].apply(lambda x : np.random.choice(school))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "12"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "school_detail = ['财务会计学院',\n",
    "                 '管理学院',\n",
    "                 '经济学院',\n",
    "                 '计算机学院',\n",
    "                 '电气学院',\n",
    "                 '机械学院',\n",
    "                 '建筑学院',\n",
    "                 '土木与环境工程学院',\n",
    "                 '外国语学院',\n",
    "                 '文学与传媒学院',\n",
    "                 '理学院',\n",
    "                 '艺术学院']\n",
    "\n",
    "p_school = [0.11,0.3,0.1,0.1,0.02,0.04,0.02,0.2,0.03,0.03,0.02,0.03]\n",
    "sum(p_school)\n",
    "len(school_detail)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['school_detail'] = user_data['school_detail'].apply(lambda x : np.random.choice(school_detail,p=p_school))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "for i in range(0,len(user_data)):\n",
    "    if user_data['school_detail'][i] == '财务会计学院':\n",
    "        user_data['major_parent'][i] = '管理学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['审计','会计','财务管理'],p=[0.2,0.4,0.4])\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '管理学院':\n",
    "        user_data['major_parent'][i] = '管理学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['工商管理','市场营销','人力资源'],p=[0.4,0.4,0.2])\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '经济学院':\n",
    "        user_data['major_parent'][i] = '经济学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['金融学','投资学','国际经济与贸易','保险学','电子商务','经济学'],p=[0.2,0.1,0.1,0.1,0.1,0.4])\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '计算机学院':\n",
    "        user_data['major_parent'][i] = '工学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['网络工程','软件工程','网络安全','应用开发'],p=[0.3,0.4,0.1,0.2])\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '电气学院':\n",
    "        user_data['major_parent'][i] = '工学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['电气工程','自动化','通信工程','微电子','信息工程'])\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '机械学院':\n",
    "        user_data['major_parent'][i] = '工学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['机械电子工程','机械设计与制造','智能控制','测控技术与仪器'],p=[0.4,0.3,0.1,0.2])\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '建筑学院':\n",
    "        user_data['major_detail'][i] = np.random.choice(['建筑学','城乡规划'],p=[0.7,0.3])\n",
    "        user_data['major_parent'][i] = '工学'\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '土木与环境工程学院':\n",
    "        user_data['major_parent'][i] = '工学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['给排水科学与工程','建筑工程技术','土木工程'],p=[0.1,0.4,0.5])\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '外国语学院':\n",
    "        user_data['major_parent'][i] = '文学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['英语','日语','法语','旅游英语'],p=[0.3,0.2,0.2,0.3])\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '文学与传媒学院':\n",
    "        user_data['major_parent'][i] = '文学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['汉语言文学','新闻学','广告学','行政管理','网络与新媒体'])\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '理学院':\n",
    "        user_data['major_parent'][i] = '理学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['应用数学','物理学','化学','信息与计算科学'])\n",
    "    \n",
    "    elif user_data['school_detail'][i] == '艺术学院':\n",
    "        user_data['major_parent'][i] = '艺术学'\n",
    "        user_data['major_detail'][i] = np.random.choice(['绘画','产品设计','服装设计','视觉传达','舞蹈表演','播音主持','表演','广播电视编导'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['interest_parent']=''\n",
    "user_data['interest_detail']=''\n",
    "interest_parent = [\n",
    "                   '综艺',\n",
    "                   '影视',\n",
    "                   '名人',\n",
    "                   '美食',\n",
    "                   '技能',\n",
    "                   '动漫',\n",
    "                   ]\n",
    "\n",
    "user_data['interest_parent'] = user_data['interest_parent'].apply(lambda x : np.random.choice(interest_parent))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "for i in range(0,len(user_data)):\n",
    "    if user_data['interest_parent'][i] == '综艺':\n",
    "        user_data['interest_detail'][i] = np.random.choice(['演员的诞生','档案','蒙面唱将猜猜猜','中国式相亲','真正男子汉','笑傲江湖','我们十七岁','老梁故事汇','中国好声音','创造101','热血街舞团','快乐大本营','天天向上','奔跑吧','非诚勿扰','极限挑张'])\n",
    "    \n",
    "    elif user_data['interest_parent'][i] == '影视':\n",
    "        user_data['interest_detail'][i] = np.random.choice(['泰坦尼克号','复仇者联盟','一代宗师','霸王别姬','海豚湾','阿甘正传','美丽人生','环太平洋','终结者','寻梦幻游记','帕丁顿熊','迪斯尼','漫威','缝纫机乐队','让子弹飞','春娇与志明'])\n",
    "    \n",
    "    elif user_data['interest_parent'][i] == '名人':\n",
    "        user_data['interest_detail'][i] = np.random.choice(['GALA','冯小刚','迈克尔·杰克逊','宋冬野','泰勒·斯威夫特','赵丽颖','迪丽热巴','鹿晗','林允','张瀚','张艺兴','吴亦凡','杨幂','周杰伦','黄子韬','新垣结衣'])\n",
    "    \n",
    "    elif user_data['interest_parent'][i] == '美食':\n",
    "        user_data['interest_detail'][i] = np.random.choice(['口水鸡','酸菜鱼','卤肉饭','糖醋排骨','三汁焖锅','烤肉','寿司','火锅','串串香','钵钵鸡','豆腐脑','牛肉面','鱼香肉丝','麻婆豆腐'])\n",
    "    \n",
    "    elif user_data['interest_parent'][i] == '技能':\n",
    "        user_data['interest_detail'][i] = np.random.choice(['设计','编程','策划','绘画','料理','文案','电子音乐','花艺','摄影','书法','写作'])\n",
    "    \n",
    "    elif user_data['interest_parent'][i] == '动漫':\n",
    "        user_data['interest_detail'][i] = np.random.choice(['火影忍者','七龙珠','灌篮高手','搞笑漫画日和','辛普森的一家','中国惊奇先生','死神','喜羊羊和灰太狼','无头骑士异闻录','海贼王','妖精的尾巴','命运石之门'])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['interest_parent1']=''\n",
    "user_data['interest_detail1']=''\n",
    "interest_parent = [\n",
    "                   '综艺',\n",
    "                   '影视',\n",
    "                   '名人',\n",
    "                   '美食',\n",
    "                   '技能',\n",
    "                   '动漫',\n",
    "                   ]\n",
    "\n",
    "user_data['interest_parent1'] = user_data['interest_parent1'].apply(lambda x : np.random.choice(interest_parent))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "for i in range(0,len(user_data)):\n",
    "    if user_data['interest_parent1'][i] == '综艺':\n",
    "        user_data['interest_detail1'][i] = np.random.choice(['演员的诞生','档案','蒙面唱将猜猜猜','中国式相亲','真正男子汉','笑傲江湖','我们十七岁','老梁故事汇','中国好声音','创造101','热血街舞团','快乐大本营','天天向上','奔跑吧','非诚勿扰','极限挑张'])\n",
    "    \n",
    "    elif user_data['interest_parent1'][i] == '影视':\n",
    "        user_data['interest_detail1'][i] = np.random.choice(['泰坦尼克号','复仇者联盟','一代宗师','霸王别姬','海豚湾','阿甘正传','美丽人生','环太平洋','终结者','寻梦幻游记','帕丁顿熊','迪斯尼','漫威','缝纫机乐队','让子弹飞','春娇与志明'])\n",
    "    \n",
    "    elif user_data['interest_parent1'][i] == '名人':\n",
    "        user_data['interest_detail1'][i] = np.random.choice(['GALA','冯小刚','迈克尔·杰克逊','宋冬野','泰勒·斯威夫特','赵丽颖','迪丽热巴','鹿晗','林允','张瀚','张艺兴','吴亦凡','杨幂','周杰伦','黄子韬','新垣结衣'])\n",
    "    \n",
    "    elif user_data['interest_parent1'][i] == '美食':\n",
    "        user_data['interest_detail1'][i] = np.random.choice(['口水鸡','酸菜鱼','卤肉饭','糖醋排骨','三汁焖锅','烤肉','寿司','火锅','串串香','钵钵鸡','豆腐脑','牛肉面','鱼香肉丝','麻婆豆腐'])\n",
    "    \n",
    "    elif user_data['interest_parent1'][i] == '技能':\n",
    "        user_data['interest_detail1'][i] = np.random.choice(['设计','编程','策划','绘画','料理','文案','电子音乐','花艺','摄影','书法','写作'])\n",
    "    \n",
    "    elif user_data['interest_parent1'][i] == '动漫':\n",
    "        user_data['interest_detail1'][i] = np.random.choice(['火影忍者','七龙珠','灌篮高手','搞笑漫画日和','辛普森的一家','中国惊奇先生','死神','喜羊羊和灰太狼','无头骑士异闻录','海贼王','妖精的尾巴','命运石之门'])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['interest_parent2']=''\n",
    "user_data['interest_detail2']=''\n",
    "interest_parent = [\n",
    "                   '综艺',\n",
    "                   '影视',\n",
    "                   '名人',\n",
    "                   '美食',\n",
    "                   '技能',\n",
    "                   '动漫',\n",
    "                   ]\n",
    "\n",
    "user_data['interest_parent2'] = user_data['interest_parent2'].apply(lambda x : np.random.choice(interest_parent))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['interest_detail3']=''\n",
    "for i in range(0,len(user_data)):\n",
    "    if user_data['interest_parent2'][i] == '综艺':\n",
    "        user_data['interest_detail3'][i] = np.random.choice(['演员的诞生','档案','蒙面唱将猜猜猜','中国式相亲','真正男子汉','笑傲江湖','我们十七岁','老梁故事汇','中国好声音','创造101','热血街舞团','快乐大本营','天天向上','奔跑吧','非诚勿扰','极限挑张'])\n",
    "    \n",
    "    elif user_data['interest_parent2'][i] == '影视':\n",
    "        user_data['interest_detail3'][i] = np.random.choice(['泰坦尼克号','复仇者联盟','一代宗师','霸王别姬','海豚湾','阿甘正传','美丽人生','环太平洋','终结者','寻梦幻游记','帕丁顿熊','迪斯尼','漫威','缝纫机乐队','让子弹飞','春娇与志明'])\n",
    "    \n",
    "    elif user_data['interest_parent2'][i] == '名人':\n",
    "        user_data['interest_detail3'][i] = np.random.choice(['GALA','冯小刚','迈克尔·杰克逊','宋冬野','泰勒·斯威夫特','赵丽颖','迪丽热巴','鹿晗','林允','张瀚','张艺兴','吴亦凡','杨幂','周杰伦','黄子韬','新垣结衣'])\n",
    "    \n",
    "    elif user_data['interest_parent2'][i] == '美食':\n",
    "        user_data['interest_detail3'][i] = np.random.choice(['口水鸡','酸菜鱼','卤肉饭','糖醋排骨','三汁焖锅','烤肉','寿司','火锅','串串香','钵钵鸡','豆腐脑','牛肉面','鱼香肉丝','麻婆豆腐'])\n",
    "    \n",
    "    elif user_data['interest_parent2'][i] == '技能':\n",
    "        user_data['interest_detail3'][i] = np.random.choice(['设计','编程','策划','绘画','料理','文案','电子音乐','花艺','摄影','书法','写作'])\n",
    "    \n",
    "    elif user_data['interest_parent2'][i] == '动漫':\n",
    "        user_data['interest_detail3'][i] = np.random.choice(['火影忍者','七龙珠','灌篮高手','搞笑漫画日和','辛普森的一家','中国惊奇先生','死神','喜羊羊和灰太狼','无头骑士异闻录','海贼王','妖精的尾巴','命运石之门'])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['interest_detail6']=''\n",
    "for i in range(0,len(user_data)):\n",
    "    if user_data['interest_parent2'][i] == '综艺':\n",
    "        user_data['interest_detail6'][i] = np.random.choice(['演员的诞生','档案','蒙面唱将猜猜猜','中国式相亲','真正男子汉','笑傲江湖','我们十七岁','老梁故事汇','中国好声音','创造101','热血街舞团','快乐大本营','天天向上','奔跑吧','非诚勿扰','极限挑张'])\n",
    "    \n",
    "    elif user_data['interest_parent2'][i] == '影视':\n",
    "        user_data['interest_detail6'][i] = np.random.choice(['泰坦尼克号','复仇者联盟','一代宗师','霸王别姬','海豚湾','阿甘正传','美丽人生','环太平洋','终结者','寻梦幻游记','帕丁顿熊','迪斯尼','漫威','缝纫机乐队','让子弹飞','春娇与志明'])\n",
    "    \n",
    "    elif user_data['interest_parent2'][i] == '名人':\n",
    "        user_data['interest_detail6'][i] = np.random.choice(['GALA','冯小刚','迈克尔·杰克逊','宋冬野','泰勒·斯威夫特','赵丽颖','迪丽热巴','鹿晗','林允','张瀚','张艺兴','吴亦凡','杨幂','周杰伦','黄子韬','新垣结衣'])\n",
    "    \n",
    "    elif user_data['interest_parent2'][i] == '美食':\n",
    "        user_data['interest_detail6'][i] = np.random.choice(['口水鸡','酸菜鱼','卤肉饭','糖醋排骨','三汁焖锅','烤肉','寿司','火锅','串串香','钵钵鸡','豆腐脑','牛肉面','鱼香肉丝','麻婆豆腐'])\n",
    "    \n",
    "    elif user_data['interest_parent2'][i] == '技能':\n",
    "        user_data['interest_detail6'][i] = np.random.choice(['设计','编程','策划','绘画','料理','文案','电子音乐','花艺','摄影','书法','写作'])\n",
    "    \n",
    "    elif user_data['interest_parent2'][i] == '动漫':\n",
    "        user_data['interest_detail6'][i] = np.random.choice(['火影忍者','七龙珠','灌篮高手','搞笑漫画日和','辛普森的一家','中国惊奇先生','死神','喜羊羊和灰太狼','无头骑士异闻录','海贼王','妖精的尾巴','命运石之门'])\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>region_parent</th>\n",
       "      <th>region_detail</th>\n",
       "      <th>school_parent</th>\n",
       "      <th>school_detail</th>\n",
       "      <th>major_parent</th>\n",
       "      <th>major_detail</th>\n",
       "      <th>interest_parent</th>\n",
       "      <th>interest_detail</th>\n",
       "      <th>interest_parent1</th>\n",
       "      <th>interest_detail1</th>\n",
       "      <th>interest_parent2</th>\n",
       "      <th>interest_detail2</th>\n",
       "      <th>year</th>\n",
       "      <th>interest_detail3</th>\n",
       "      <th>interest_detail4</th>\n",
       "      <th>interest_detail5</th>\n",
       "      <th>interest_detail6</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10000</td>\n",
       "      <td>四川</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>软件工程</td>\n",
       "      <td>名人</td>\n",
       "      <td>杨幂</td>\n",
       "      <td>美食</td>\n",
       "      <td>串串香</td>\n",
       "      <td>美食</td>\n",
       "      <td>火锅</td>\n",
       "      <td>2012</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>三汁焖锅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10001</td>\n",
       "      <td>四川</td>\n",
       "      <td>眉山市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>综艺</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>美食</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>技能</td>\n",
       "      <td>花艺</td>\n",
       "      <td>2013</td>\n",
       "      <td>书法</td>\n",
       "      <td>摄影</td>\n",
       "      <td>写作</td>\n",
       "      <td>写作</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10002</td>\n",
       "      <td>四川</td>\n",
       "      <td>达州市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>审计</td>\n",
       "      <td>综艺</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>影视</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>名人</td>\n",
       "      <td>张瀚</td>\n",
       "      <td>2010</td>\n",
       "      <td>林允</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>张瀚</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10003</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>技能</td>\n",
       "      <td>文案</td>\n",
       "      <td>动漫</td>\n",
       "      <td>无头骑士异闻录</td>\n",
       "      <td>影视</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>2008</td>\n",
       "      <td>终结者</td>\n",
       "      <td>迪斯尼</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>终结者</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10004</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>影视</td>\n",
       "      <td>一代宗师</td>\n",
       "      <td>影视</td>\n",
       "      <td>帕丁顿熊</td>\n",
       "      <td>名人</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>2013</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>黄子韬</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>10005</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>名人</td>\n",
       "      <td>林允</td>\n",
       "      <td>名人</td>\n",
       "      <td>林允</td>\n",
       "      <td>美食</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>2013</td>\n",
       "      <td>串串香</td>\n",
       "      <td>三汁焖锅</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>三汁焖锅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>10006</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>财务管理</td>\n",
       "      <td>技能</td>\n",
       "      <td>文案</td>\n",
       "      <td>名人</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>影视</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>2017</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>霸王别姬</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>10007</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>名人</td>\n",
       "      <td>黄子韬</td>\n",
       "      <td>美食</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>综艺</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>2013</td>\n",
       "      <td>档案</td>\n",
       "      <td>热血街舞团</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>演员的诞生</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>10008</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>名人</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>动漫</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>动漫</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>2015</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>无头骑士异闻录</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>辛普森的一家</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10009</td>\n",
       "      <td>四川</td>\n",
       "      <td>眉山市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>影视</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>美食</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>美食</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>2010</td>\n",
       "      <td>三汁焖锅</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10010</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>综艺</td>\n",
       "      <td>创造101</td>\n",
       "      <td>技能</td>\n",
       "      <td>摄影</td>\n",
       "      <td>美食</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>2006</td>\n",
       "      <td>寿司</td>\n",
       "      <td>鱼香肉丝</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>火锅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>10011</td>\n",
       "      <td>四川</td>\n",
       "      <td>绵阳市</td>\n",
       "      <td>四川大学锦城学院</td>\n",
       "      <td>艺术学院</td>\n",
       "      <td>艺术学</td>\n",
       "      <td>绘画</td>\n",
       "      <td>综艺</td>\n",
       "      <td>热血街舞团</td>\n",
       "      <td>影视</td>\n",
       "      <td>霸王别姬</td>\n",
       "      <td>综艺</td>\n",
       "      <td>极限挑张</td>\n",
       "      <td>2003</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>档案</td>\n",
       "      <td>极限挑张</td>\n",
       "      <td>非诚勿扰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>10012</td>\n",
       "      <td>四川</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>土木工程</td>\n",
       "      <td>综艺</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>动漫</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>名人</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>2007</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>迈克尔·杰克逊</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>冯小刚</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>10013</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>美食</td>\n",
       "      <td>麻婆豆腐</td>\n",
       "      <td>名人</td>\n",
       "      <td>张瀚</td>\n",
       "      <td>影视</td>\n",
       "      <td>漫威</td>\n",
       "      <td>2008</td>\n",
       "      <td>一代宗师</td>\n",
       "      <td>帕丁顿熊</td>\n",
       "      <td>缝纫机乐队</td>\n",
       "      <td>春娇与志明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>10014</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>动漫</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>影视</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>名人</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>2002</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>GALA</td>\n",
       "      <td>GALA</td>\n",
       "      <td>新垣结衣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>10015</td>\n",
       "      <td>四川</td>\n",
       "      <td>绵阳市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>机械学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>机械电子工程</td>\n",
       "      <td>动漫</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>美食</td>\n",
       "      <td>三汁焖锅</td>\n",
       "      <td>动漫</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>2017</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>死神</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>10016</td>\n",
       "      <td>四川</td>\n",
       "      <td>绵阳市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>技能</td>\n",
       "      <td>绘画</td>\n",
       "      <td>名人</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>技能</td>\n",
       "      <td>花艺</td>\n",
       "      <td>2013</td>\n",
       "      <td>绘画</td>\n",
       "      <td>花艺</td>\n",
       "      <td>写作</td>\n",
       "      <td>写作</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>10017</td>\n",
       "      <td>四川</td>\n",
       "      <td>资阳市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>金融学</td>\n",
       "      <td>影视</td>\n",
       "      <td>漫威</td>\n",
       "      <td>综艺</td>\n",
       "      <td>笑傲江湖</td>\n",
       "      <td>影视</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>2005</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>阿甘正传</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>霸王别姬</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>10018</td>\n",
       "      <td>四川</td>\n",
       "      <td>德阳市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>机械学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>机械电子工程</td>\n",
       "      <td>美食</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>动漫</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>名人</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>2010</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>新垣结衣</td>\n",
       "      <td>GALA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>10019</td>\n",
       "      <td>四川</td>\n",
       "      <td>南充市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>美食</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>技能</td>\n",
       "      <td>料理</td>\n",
       "      <td>名人</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>2006</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>宋冬野</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>10020</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>美食</td>\n",
       "      <td>火锅</td>\n",
       "      <td>动漫</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>综艺</td>\n",
       "      <td>档案</td>\n",
       "      <td>2003</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>快乐大本营</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>真正男子汉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>10021</td>\n",
       "      <td>四川</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>四川大学锦城学院</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>技能</td>\n",
       "      <td>策划</td>\n",
       "      <td>影视</td>\n",
       "      <td>帕丁顿熊</td>\n",
       "      <td>名人</td>\n",
       "      <td>周杰伦</td>\n",
       "      <td>2014</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>张艺兴</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>10022</td>\n",
       "      <td>四川</td>\n",
       "      <td>泸州市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>会计</td>\n",
       "      <td>综艺</td>\n",
       "      <td>档案</td>\n",
       "      <td>美食</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>影视</td>\n",
       "      <td>寻梦幻游记</td>\n",
       "      <td>2014</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>终结者</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>缝纫机乐队</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>10023</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>影视</td>\n",
       "      <td>缝纫机乐队</td>\n",
       "      <td>综艺</td>\n",
       "      <td>热血街舞团</td>\n",
       "      <td>影视</td>\n",
       "      <td>寻梦幻游记</td>\n",
       "      <td>2016</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>漫威</td>\n",
       "      <td>漫威</td>\n",
       "      <td>环太平洋</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>10024</td>\n",
       "      <td>四川</td>\n",
       "      <td>资阳市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>动漫</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>动漫</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>综艺</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>2002</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>创造101</td>\n",
       "      <td>非诚勿扰</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>10025</td>\n",
       "      <td>四川</td>\n",
       "      <td>达州市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>影视</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>综艺</td>\n",
       "      <td>创造101</td>\n",
       "      <td>影视</td>\n",
       "      <td>缝纫机乐队</td>\n",
       "      <td>2000</td>\n",
       "      <td>春娇与志明</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>10026</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>动漫</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>名人</td>\n",
       "      <td>张瀚</td>\n",
       "      <td>名人</td>\n",
       "      <td>张瀚</td>\n",
       "      <td>2014</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>GALA</td>\n",
       "      <td>黄子韬</td>\n",
       "      <td>杨幂</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>10027</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>影视</td>\n",
       "      <td>迪斯尼</td>\n",
       "      <td>名人</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>美食</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>2010</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>糖醋排骨</td>\n",
       "      <td>牛肉面</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>10028</td>\n",
       "      <td>四川</td>\n",
       "      <td>眉山市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>土木工程</td>\n",
       "      <td>影视</td>\n",
       "      <td>寻梦幻游记</td>\n",
       "      <td>技能</td>\n",
       "      <td>绘画</td>\n",
       "      <td>技能</td>\n",
       "      <td>料理</td>\n",
       "      <td>2009</td>\n",
       "      <td>花艺</td>\n",
       "      <td>编程</td>\n",
       "      <td>书法</td>\n",
       "      <td>绘画</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>10029</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>金融学</td>\n",
       "      <td>美食</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>名人</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>综艺</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>2003</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>创造101</td>\n",
       "      <td>蒙面唱将猜猜猜</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>970</th>\n",
       "      <td>10970</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>美食</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>动漫</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>动漫</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>2015</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>命运石之门</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>971</th>\n",
       "      <td>10971</td>\n",
       "      <td>四川</td>\n",
       "      <td>达州市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>名人</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>美食</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>技能</td>\n",
       "      <td>书法</td>\n",
       "      <td>2003</td>\n",
       "      <td>策划</td>\n",
       "      <td>设计</td>\n",
       "      <td>书法</td>\n",
       "      <td>摄影</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>10972</td>\n",
       "      <td>四川</td>\n",
       "      <td>泸州市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>名人</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>综艺</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>动漫</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>2005</td>\n",
       "      <td>无头骑士异闻录</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>灌篮高手</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>10973</td>\n",
       "      <td>四川</td>\n",
       "      <td>泸州市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>市场营销</td>\n",
       "      <td>动漫</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>动漫</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>美食</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>2013</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>寿司</td>\n",
       "      <td>牛肉面</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>10974</td>\n",
       "      <td>四川</td>\n",
       "      <td>广元市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>文学与传媒学院</td>\n",
       "      <td>文学</td>\n",
       "      <td>行政管理</td>\n",
       "      <td>影视</td>\n",
       "      <td>终结者</td>\n",
       "      <td>名人</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>动漫</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>2006</td>\n",
       "      <td>火影忍者</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>10975</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>美食</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>名人</td>\n",
       "      <td>赵丽颖</td>\n",
       "      <td>动漫</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>2010</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>命运石之门</td>\n",
       "      <td>命运石之门</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976</th>\n",
       "      <td>10976</td>\n",
       "      <td>四川</td>\n",
       "      <td>广安市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>文学与传媒学院</td>\n",
       "      <td>文学</td>\n",
       "      <td>新闻学</td>\n",
       "      <td>名人</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>影视</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>美食</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>2011</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>火锅</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>火锅</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>10977</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>建筑工程技术</td>\n",
       "      <td>美食</td>\n",
       "      <td>鱼香肉丝</td>\n",
       "      <td>动漫</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>影视</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>2005</td>\n",
       "      <td>迪斯尼</td>\n",
       "      <td>环太平洋</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>漫威</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>10978</td>\n",
       "      <td>四川</td>\n",
       "      <td>绵阳市</td>\n",
       "      <td>四川大学锦城学院</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>会计</td>\n",
       "      <td>动漫</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>美食</td>\n",
       "      <td>串串香</td>\n",
       "      <td>美食</td>\n",
       "      <td>串串香</td>\n",
       "      <td>2002</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>糖醋排骨</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>10979</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>动漫</td>\n",
       "      <td>海贼王</td>\n",
       "      <td>技能</td>\n",
       "      <td>花艺</td>\n",
       "      <td>综艺</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>2000</td>\n",
       "      <td>创造101</td>\n",
       "      <td>蒙面唱将猜猜猜</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>极限挑张</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>10980</td>\n",
       "      <td>四川</td>\n",
       "      <td>攀枝花市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>投资学</td>\n",
       "      <td>综艺</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>动漫</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>美食</td>\n",
       "      <td>酸菜鱼</td>\n",
       "      <td>2008</td>\n",
       "      <td>卤肉饭</td>\n",
       "      <td>寿司</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>烤肉</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>10981</td>\n",
       "      <td>四川</td>\n",
       "      <td>遂宁市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>人力资源</td>\n",
       "      <td>动漫</td>\n",
       "      <td>死神</td>\n",
       "      <td>美食</td>\n",
       "      <td>豆腐脑</td>\n",
       "      <td>综艺</td>\n",
       "      <td>热血街舞团</td>\n",
       "      <td>2012</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>创造101</td>\n",
       "      <td>蒙面唱将猜猜猜</td>\n",
       "      <td>快乐大本营</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>10982</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>会计</td>\n",
       "      <td>影视</td>\n",
       "      <td>霸王别姬</td>\n",
       "      <td>名人</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>名人</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>2013</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>新垣结衣</td>\n",
       "      <td>黄子韬</td>\n",
       "      <td>新垣结衣</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>10983</td>\n",
       "      <td>四川</td>\n",
       "      <td>雅安市</td>\n",
       "      <td>四川大学锦城学院</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>美食</td>\n",
       "      <td>串串香</td>\n",
       "      <td>动漫</td>\n",
       "      <td>中国惊奇先生</td>\n",
       "      <td>美食</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>2012</td>\n",
       "      <td>火锅</td>\n",
       "      <td>三汁焖锅</td>\n",
       "      <td>火锅</td>\n",
       "      <td>口水鸡</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>10984</td>\n",
       "      <td>四川</td>\n",
       "      <td>内江市</td>\n",
       "      <td>四川师范大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>网络工程</td>\n",
       "      <td>综艺</td>\n",
       "      <td>中国式相亲</td>\n",
       "      <td>技能</td>\n",
       "      <td>书法</td>\n",
       "      <td>技能</td>\n",
       "      <td>摄影</td>\n",
       "      <td>2010</td>\n",
       "      <td>摄影</td>\n",
       "      <td>花艺</td>\n",
       "      <td>绘画</td>\n",
       "      <td>写作</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>10985</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>经济学院</td>\n",
       "      <td>经济学</td>\n",
       "      <td>经济学</td>\n",
       "      <td>名人</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>影视</td>\n",
       "      <td>帕丁顿熊</td>\n",
       "      <td>技能</td>\n",
       "      <td>绘画</td>\n",
       "      <td>2010</td>\n",
       "      <td>编程</td>\n",
       "      <td>摄影</td>\n",
       "      <td>策划</td>\n",
       "      <td>文案</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>10986</td>\n",
       "      <td>四川</td>\n",
       "      <td>攀枝花市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>文学与传媒学院</td>\n",
       "      <td>文学</td>\n",
       "      <td>广告学</td>\n",
       "      <td>美食</td>\n",
       "      <td>口水鸡</td>\n",
       "      <td>名人</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>综艺</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>2000</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>极限挑张</td>\n",
       "      <td>极限挑张</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>10987</td>\n",
       "      <td>四川</td>\n",
       "      <td>乐山市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>文学与传媒学院</td>\n",
       "      <td>文学</td>\n",
       "      <td>网络与新媒体</td>\n",
       "      <td>影视</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>名人</td>\n",
       "      <td>张瀚</td>\n",
       "      <td>影视</td>\n",
       "      <td>缝纫机乐队</td>\n",
       "      <td>2016</td>\n",
       "      <td>迪斯尼</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>迪斯尼</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>10988</td>\n",
       "      <td>四川</td>\n",
       "      <td>攀枝花市</td>\n",
       "      <td>西华大学</td>\n",
       "      <td>文学与传媒学院</td>\n",
       "      <td>文学</td>\n",
       "      <td>行政管理</td>\n",
       "      <td>影视</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>美食</td>\n",
       "      <td>烤肉</td>\n",
       "      <td>综艺</td>\n",
       "      <td>真正男子汉</td>\n",
       "      <td>2009</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>创造101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>10989</td>\n",
       "      <td>四川</td>\n",
       "      <td>内江市</td>\n",
       "      <td>四川大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>审计</td>\n",
       "      <td>综艺</td>\n",
       "      <td>热血街舞团</td>\n",
       "      <td>美食</td>\n",
       "      <td>钵钵鸡</td>\n",
       "      <td>名人</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>2017</td>\n",
       "      <td>吴亦凡</td>\n",
       "      <td>鹿晗</td>\n",
       "      <td>周杰伦</td>\n",
       "      <td>赵丽颖</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>10990</td>\n",
       "      <td>四川</td>\n",
       "      <td>眉山市</td>\n",
       "      <td>西南石油大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>综艺</td>\n",
       "      <td>非诚勿扰</td>\n",
       "      <td>名人</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>动漫</td>\n",
       "      <td>无头骑士异闻录</td>\n",
       "      <td>2000</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>无头骑士异闻录</td>\n",
       "      <td>海贼王</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>10991</td>\n",
       "      <td>四川</td>\n",
       "      <td>达州市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>管理学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>工商管理</td>\n",
       "      <td>技能</td>\n",
       "      <td>设计</td>\n",
       "      <td>动漫</td>\n",
       "      <td>搞笑漫画日和</td>\n",
       "      <td>综艺</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>2001</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>热血街舞团</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>10992</td>\n",
       "      <td>四川</td>\n",
       "      <td>自贡市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>文学与传媒学院</td>\n",
       "      <td>文学</td>\n",
       "      <td>行政管理</td>\n",
       "      <td>名人</td>\n",
       "      <td>宋冬野</td>\n",
       "      <td>影视</td>\n",
       "      <td>寻梦幻游记</td>\n",
       "      <td>技能</td>\n",
       "      <td>绘画</td>\n",
       "      <td>2017</td>\n",
       "      <td>编程</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>料理</td>\n",
       "      <td>料理</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>10993</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>应用开发</td>\n",
       "      <td>技能</td>\n",
       "      <td>设计</td>\n",
       "      <td>影视</td>\n",
       "      <td>终结者</td>\n",
       "      <td>综艺</td>\n",
       "      <td>天天向上</td>\n",
       "      <td>2004</td>\n",
       "      <td>档案</td>\n",
       "      <td>我们十七岁</td>\n",
       "      <td>老梁故事汇</td>\n",
       "      <td>奔跑吧</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>10994</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>西南交通大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>给排水科学与工程</td>\n",
       "      <td>技能</td>\n",
       "      <td>文案</td>\n",
       "      <td>动漫</td>\n",
       "      <td>灌篮高手</td>\n",
       "      <td>影视</td>\n",
       "      <td>一代宗师</td>\n",
       "      <td>2005</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>缝纫机乐队</td>\n",
       "      <td>泰坦尼克号</td>\n",
       "      <td>一代宗师</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>10995</td>\n",
       "      <td>四川</td>\n",
       "      <td>达州市</td>\n",
       "      <td>成都信息工程大学</td>\n",
       "      <td>财务会计学院</td>\n",
       "      <td>管理学</td>\n",
       "      <td>财务管理</td>\n",
       "      <td>名人</td>\n",
       "      <td>张艺兴</td>\n",
       "      <td>美食</td>\n",
       "      <td>牛肉面</td>\n",
       "      <td>影视</td>\n",
       "      <td>复仇者联盟</td>\n",
       "      <td>2012</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>让子弹飞</td>\n",
       "      <td>春娇与志明</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>10996</td>\n",
       "      <td>四川</td>\n",
       "      <td>成都市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>土木与环境工程学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>土木工程</td>\n",
       "      <td>名人</td>\n",
       "      <td>迪丽热巴</td>\n",
       "      <td>动漫</td>\n",
       "      <td>七龙珠</td>\n",
       "      <td>影视</td>\n",
       "      <td>美丽人生</td>\n",
       "      <td>2013</td>\n",
       "      <td>寻梦幻游记</td>\n",
       "      <td>霸王别姬</td>\n",
       "      <td>终结者</td>\n",
       "      <td>海豚湾</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>10997</td>\n",
       "      <td>重庆</td>\n",
       "      <td>重庆</td>\n",
       "      <td>电子科技大学</td>\n",
       "      <td>机械学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>机械设计与制造</td>\n",
       "      <td>技能</td>\n",
       "      <td>文案</td>\n",
       "      <td>名人</td>\n",
       "      <td>冯小刚</td>\n",
       "      <td>动漫</td>\n",
       "      <td>喜羊羊和灰太狼</td>\n",
       "      <td>2000</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>辛普森的一家</td>\n",
       "      <td>妖精的尾巴</td>\n",
       "      <td>火影忍者</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>10998</td>\n",
       "      <td>四川</td>\n",
       "      <td>宜宾市</td>\n",
       "      <td>成都理工大学</td>\n",
       "      <td>机械学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>机械电子工程</td>\n",
       "      <td>名人</td>\n",
       "      <td>黄子韬</td>\n",
       "      <td>综艺</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>技能</td>\n",
       "      <td>摄影</td>\n",
       "      <td>2012</td>\n",
       "      <td>文案</td>\n",
       "      <td>绘画</td>\n",
       "      <td>电子音乐</td>\n",
       "      <td>摄影</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>10999</td>\n",
       "      <td>四川</td>\n",
       "      <td>绵阳市</td>\n",
       "      <td>西南财经大学</td>\n",
       "      <td>计算机学院</td>\n",
       "      <td>工学</td>\n",
       "      <td>应用开发</td>\n",
       "      <td>名人</td>\n",
       "      <td>泰勒·斯威夫特</td>\n",
       "      <td>影视</td>\n",
       "      <td>海豚湾</td>\n",
       "      <td>综艺</td>\n",
       "      <td>笑傲江湖</td>\n",
       "      <td>2015</td>\n",
       "      <td>演员的诞生</td>\n",
       "      <td>中国好声音</td>\n",
       "      <td>奔跑吧</td>\n",
       "      <td>极限挑张</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id region_parent region_detail school_parent school_detail  \\\n",
       "0    10000            四川           乐山市        西南交通大学         计算机学院   \n",
       "1    10001            四川           眉山市        西南交通大学     土木与环境工程学院   \n",
       "2    10002            四川           达州市        成都理工大学        财务会计学院   \n",
       "3    10003            四川           成都市        西南交通大学          管理学院   \n",
       "4    10004            四川           德阳市      成都信息工程大学          经济学院   \n",
       "5    10005            四川           德阳市          西华大学     土木与环境工程学院   \n",
       "6    10006            四川           广元市        西南石油大学        财务会计学院   \n",
       "7    10007            重庆            重庆        西南石油大学     土木与环境工程学院   \n",
       "8    10008            四川           德阳市        成都理工大学          管理学院   \n",
       "9    10009            四川           眉山市        西南财经大学     土木与环境工程学院   \n",
       "10   10010            四川           广元市        电子科技大学     土木与环境工程学院   \n",
       "11   10011            四川           绵阳市      四川大学锦城学院          艺术学院   \n",
       "12   10012            四川           乐山市        西南石油大学     土木与环境工程学院   \n",
       "13   10013            四川           广元市        四川师范大学          经济学院   \n",
       "14   10014            四川           成都市        西南石油大学     土木与环境工程学院   \n",
       "15   10015            四川           绵阳市        电子科技大学          机械学院   \n",
       "16   10016            四川           绵阳市        西南石油大学          管理学院   \n",
       "17   10017            四川           资阳市        电子科技大学          经济学院   \n",
       "18   10018            四川           德阳市        四川师范大学          机械学院   \n",
       "19   10019            四川           南充市          四川大学     土木与环境工程学院   \n",
       "20   10020            四川           广元市        电子科技大学          管理学院   \n",
       "21   10021            四川           宜宾市      四川大学锦城学院          管理学院   \n",
       "22   10022            四川           泸州市        西南财经大学        财务会计学院   \n",
       "23   10023            四川           自贡市        西南石油大学          管理学院   \n",
       "24   10024            四川           资阳市        西南石油大学          管理学院   \n",
       "25   10025            四川           达州市        成都理工大学          管理学院   \n",
       "26   10026            四川           广元市        西南石油大学          经济学院   \n",
       "27   10027            四川           成都市      成都信息工程大学          管理学院   \n",
       "28   10028            四川           眉山市          四川大学     土木与环境工程学院   \n",
       "29   10029            四川           自贡市        四川师范大学          经济学院   \n",
       "..     ...           ...           ...           ...           ...   \n",
       "970  10970            四川           成都市        西南石油大学          经济学院   \n",
       "971  10971            四川           达州市        西南交通大学          管理学院   \n",
       "972  10972            四川           泸州市        成都理工大学          经济学院   \n",
       "973  10973            四川           泸州市          四川大学          管理学院   \n",
       "974  10974            四川           广元市        电子科技大学       文学与传媒学院   \n",
       "975  10975            四川           成都市      成都信息工程大学          管理学院   \n",
       "976  10976            四川           广安市        西南交通大学       文学与传媒学院   \n",
       "977  10977            四川           自贡市        电子科技大学     土木与环境工程学院   \n",
       "978  10978            四川           绵阳市      四川大学锦城学院        财务会计学院   \n",
       "979  10979            四川           成都市        西南财经大学          管理学院   \n",
       "980  10980            四川          攀枝花市        西南财经大学          经济学院   \n",
       "981  10981            四川           遂宁市        成都理工大学          管理学院   \n",
       "982  10982            重庆            重庆        四川师范大学        财务会计学院   \n",
       "983  10983            四川           雅安市      四川大学锦城学院          管理学院   \n",
       "984  10984            四川           内江市        四川师范大学         计算机学院   \n",
       "985  10985            四川           成都市        成都理工大学          经济学院   \n",
       "986  10986            四川          攀枝花市          西华大学       文学与传媒学院   \n",
       "987  10987            四川           乐山市      成都信息工程大学       文学与传媒学院   \n",
       "988  10988            四川          攀枝花市          西华大学       文学与传媒学院   \n",
       "989  10989            四川           内江市          四川大学        财务会计学院   \n",
       "990  10990            四川           眉山市        西南石油大学          管理学院   \n",
       "991  10991            四川           达州市      成都信息工程大学          管理学院   \n",
       "992  10992            四川           自贡市      成都信息工程大学       文学与传媒学院   \n",
       "993  10993            四川           成都市      成都信息工程大学         计算机学院   \n",
       "994  10994            四川           成都市        西南交通大学     土木与环境工程学院   \n",
       "995  10995            四川           达州市      成都信息工程大学        财务会计学院   \n",
       "996  10996            四川           成都市        成都理工大学     土木与环境工程学院   \n",
       "997  10997            重庆            重庆        电子科技大学          机械学院   \n",
       "998  10998            四川           宜宾市        成都理工大学          机械学院   \n",
       "999  10999            四川           绵阳市        西南财经大学         计算机学院   \n",
       "\n",
       "    major_parent major_detail interest_parent interest_detail  \\\n",
       "0             工学         软件工程              名人              杨幂   \n",
       "1             工学       建筑工程技术              综艺            非诚勿扰   \n",
       "2            管理学           审计              综艺            非诚勿扰   \n",
       "3            管理学         市场营销              技能              文案   \n",
       "4            经济学          经济学              影视            一代宗师   \n",
       "5             工学       建筑工程技术              名人              林允   \n",
       "6            管理学         财务管理              技能              文案   \n",
       "7             工学       建筑工程技术              名人             黄子韬   \n",
       "8            管理学         市场营销              名人            迪丽热巴   \n",
       "9             工学       建筑工程技术              影视           复仇者联盟   \n",
       "10            工学       建筑工程技术              综艺           创造101   \n",
       "11           艺术学           绘画              综艺           热血街舞团   \n",
       "12            工学         土木工程              综艺            天天向上   \n",
       "13           经济学          经济学              美食            麻婆豆腐   \n",
       "14            工学       建筑工程技术              动漫         喜羊羊和灰太狼   \n",
       "15            工学       机械电子工程              动漫            灌篮高手   \n",
       "16           管理学         市场营销              技能              绘画   \n",
       "17           经济学          金融学              影视              漫威   \n",
       "18            工学       机械电子工程              美食             牛肉面   \n",
       "19            工学       建筑工程技术              美食             酸菜鱼   \n",
       "20           管理学         市场营销              美食              火锅   \n",
       "21           管理学         市场营销              技能              策划   \n",
       "22           管理学           会计              综艺              档案   \n",
       "23           管理学         工商管理              影视           缝纫机乐队   \n",
       "24           管理学         工商管理              动漫            灌篮高手   \n",
       "25           管理学         工商管理              影视            美丽人生   \n",
       "26           经济学          经济学              动漫         喜羊羊和灰太狼   \n",
       "27           管理学         工商管理              影视             迪斯尼   \n",
       "28            工学         土木工程              影视           寻梦幻游记   \n",
       "29           经济学          金融学              美食             酸菜鱼   \n",
       "..           ...          ...             ...             ...   \n",
       "970          经济学          经济学              美食              烤肉   \n",
       "971          管理学         市场营销              名人              鹿晗   \n",
       "972          经济学          经济学              名人             赵丽颖   \n",
       "973          管理学         市场营销              动漫         喜羊羊和灰太狼   \n",
       "974           文学         行政管理              影视             终结者   \n",
       "975          管理学         工商管理              美食             牛肉面   \n",
       "976           文学          新闻学              名人             冯小刚   \n",
       "977           工学       建筑工程技术              美食            鱼香肉丝   \n",
       "978          管理学           会计              动漫          中国惊奇先生   \n",
       "979          管理学         工商管理              动漫             海贼王   \n",
       "980          经济学          投资学              综艺            天天向上   \n",
       "981          管理学         人力资源              动漫              死神   \n",
       "982          管理学           会计              影视            霸王别姬   \n",
       "983          管理学         工商管理              美食             串串香   \n",
       "984           工学         网络工程              综艺           中国式相亲   \n",
       "985          经济学          经济学              名人            迪丽热巴   \n",
       "986           文学          广告学              美食             口水鸡   \n",
       "987           文学       网络与新媒体              影视           复仇者联盟   \n",
       "988           文学         行政管理              影视           泰坦尼克号   \n",
       "989          管理学           审计              综艺           热血街舞团   \n",
       "990          管理学         工商管理              综艺            非诚勿扰   \n",
       "991          管理学         工商管理              技能              设计   \n",
       "992           文学         行政管理              名人             宋冬野   \n",
       "993           工学         应用开发              技能              设计   \n",
       "994           工学     给排水科学与工程              技能              文案   \n",
       "995          管理学         财务管理              名人             张艺兴   \n",
       "996           工学         土木工程              名人            迪丽热巴   \n",
       "997           工学      机械设计与制造              技能              文案   \n",
       "998           工学       机械电子工程              名人             黄子韬   \n",
       "999           工学         应用开发              名人         泰勒·斯威夫特   \n",
       "\n",
       "    interest_parent1 interest_detail1 interest_parent2 interest_detail2  year  \\\n",
       "0                 美食              串串香               美食               火锅  2012   \n",
       "1                 美食              口水鸡               技能               花艺  2013   \n",
       "2                 影视             美丽人生               名人               张瀚  2010   \n",
       "3                 动漫          无头骑士异闻录               影视              海豚湾  2008   \n",
       "4                 影视             帕丁顿熊               名人              张艺兴  2013   \n",
       "5                 名人               林允               美食              口水鸡  2013   \n",
       "6                 名人          泰勒·斯威夫特               影视             环太平洋  2017   \n",
       "7                 美食              牛肉面               综艺             非诚勿扰  2013   \n",
       "8                 动漫             火影忍者               动漫              七龙珠  2015   \n",
       "9                 美食             麻婆豆腐               美食              酸菜鱼  2010   \n",
       "10                技能               摄影               美食               烤肉  2006   \n",
       "11                影视             霸王别姬               综艺             极限挑张  2003   \n",
       "12                动漫             火影忍者               名人              张艺兴  2007   \n",
       "13                名人               张瀚               影视               漫威  2008   \n",
       "14                影视             阿甘正传               名人              宋冬野  2002   \n",
       "15                美食             三汁焖锅               动漫            妖精的尾巴  2017   \n",
       "16                名人              张艺兴               技能               花艺  2013   \n",
       "17                综艺             笑傲江湖               影视             环太平洋  2005   \n",
       "18                动漫             灌篮高手               名人          泰勒·斯威夫特  2010   \n",
       "19                技能               料理               名人              冯小刚  2006   \n",
       "20                动漫              海贼王               综艺               档案  2003   \n",
       "21                影视             帕丁顿熊               名人              周杰伦  2014   \n",
       "22                美食              口水鸡               影视            寻梦幻游记  2014   \n",
       "23                综艺            热血街舞团               影视            寻梦幻游记  2016   \n",
       "24                动漫           辛普森的一家               综艺            中国式相亲  2002   \n",
       "25                综艺            创造101               影视            缝纫机乐队  2000   \n",
       "26                名人               张瀚               名人               张瀚  2014   \n",
       "27                名人               鹿晗               美食              豆腐脑  2010   \n",
       "28                技能               绘画               技能               料理  2009   \n",
       "29                名人          泰勒·斯威夫特               综艺            演员的诞生  2003   \n",
       "..               ...              ...              ...              ...   ...   \n",
       "970               动漫            妖精的尾巴               动漫          喜羊羊和灰太狼  2015   \n",
       "971               美食              豆腐脑               技能               书法  2003   \n",
       "972               综艺              奔跑吧               动漫            妖精的尾巴  2005   \n",
       "973               动漫              七龙珠               美食              口水鸡  2013   \n",
       "974               名人              赵丽颖               动漫              七龙珠  2006   \n",
       "975               名人              赵丽颖               动漫           搞笑漫画日和  2010   \n",
       "976               影视              海豚湾               美食              牛肉面  2011   \n",
       "977               动漫           辛普森的一家               影视             让子弹飞  2005   \n",
       "978               美食              串串香               美食              串串香  2002   \n",
       "979               技能               花艺               综艺            中国好声音  2000   \n",
       "980               动漫           辛普森的一家               美食              酸菜鱼  2008   \n",
       "981               美食              豆腐脑               综艺            热血街舞团  2012   \n",
       "982               名人              张艺兴               名人              张艺兴  2013   \n",
       "983               动漫           中国惊奇先生               美食              口水鸡  2012   \n",
       "984               技能               书法               技能               摄影  2010   \n",
       "985               影视             帕丁顿熊               技能               绘画  2010   \n",
       "986               名人          泰勒·斯威夫特               综艺            中国好声音  2000   \n",
       "987               名人               张瀚               影视            缝纫机乐队  2016   \n",
       "988               美食               烤肉               综艺            真正男子汉  2009   \n",
       "989               美食              钵钵鸡               名人              宋冬野  2017   \n",
       "990               名人              宋冬野               动漫          无头骑士异闻录  2000   \n",
       "991               动漫           搞笑漫画日和               综艺              奔跑吧  2001   \n",
       "992               影视            寻梦幻游记               技能               绘画  2017   \n",
       "993               影视              终结者               综艺             天天向上  2004   \n",
       "994               动漫             灌篮高手               影视             一代宗师  2005   \n",
       "995               美食              牛肉面               影视            复仇者联盟  2012   \n",
       "996               动漫              七龙珠               影视             美丽人生  2013   \n",
       "997               名人              冯小刚               动漫          喜羊羊和灰太狼  2000   \n",
       "998               综艺              奔跑吧               技能               摄影  2012   \n",
       "999               影视              海豚湾               综艺             笑傲江湖  2015   \n",
       "\n",
       "    interest_detail3 interest_detail4 interest_detail5 interest_detail6  \n",
       "0                卤肉饭              口水鸡              酸菜鱼             三汁焖锅  \n",
       "1                 书法               摄影               写作               写作  \n",
       "2                 林允              冯小刚              冯小刚               张瀚  \n",
       "3                终结者              迪斯尼            复仇者联盟              终结者  \n",
       "4                宋冬野          泰勒·斯威夫特              冯小刚              黄子韬  \n",
       "5                串串香             三汁焖锅              牛肉面             三汁焖锅  \n",
       "6               让子弹飞             环太平洋             美丽人生             霸王别姬  \n",
       "7                 档案            热血街舞团            中国式相亲            演员的诞生  \n",
       "8              妖精的尾巴          无头骑士异闻录              七龙珠           辛普森的一家  \n",
       "9               三汁焖锅              口水鸡              豆腐脑             麻婆豆腐  \n",
       "10                寿司             鱼香肉丝              牛肉面               火锅  \n",
       "11             快乐大本营               档案             极限挑张             非诚勿扰  \n",
       "12               张艺兴          迈克尔·杰克逊          泰勒·斯威夫特              冯小刚  \n",
       "13              一代宗师             帕丁顿熊            缝纫机乐队            春娇与志明  \n",
       "14               张艺兴             GALA             GALA             新垣结衣  \n",
       "15            中国惊奇先生          喜羊羊和灰太狼              七龙珠               死神  \n",
       "16                绘画               花艺               写作               写作  \n",
       "17              让子弹飞             阿甘正传            复仇者联盟             霸王别姬  \n",
       "18               赵丽颖              冯小刚             新垣结衣             GALA  \n",
       "19               赵丽颖             迪丽热巴               鹿晗              宋冬野  \n",
       "20              天天向上            快乐大本营            我们十七岁            真正男子汉  \n",
       "21               赵丽颖             迪丽热巴              赵丽颖              张艺兴  \n",
       "22               海豚湾              终结者             让子弹飞            缝纫机乐队  \n",
       "23              环太平洋               漫威               漫威             环太平洋  \n",
       "24               奔跑吧            中国式相亲            创造101             非诚勿扰  \n",
       "25             春娇与志明            泰坦尼克号            复仇者联盟            泰坦尼克号  \n",
       "26               张艺兴             GALA              黄子韬               杨幂  \n",
       "27                烤肉             糖醋排骨             糖醋排骨              牛肉面  \n",
       "28                花艺               编程               书法               绘画  \n",
       "29             中国式相亲            我们十七岁            创造101          蒙面唱将猜猜猜  \n",
       "..               ...              ...              ...              ...  \n",
       "970              海贼王            妖精的尾巴             火影忍者            命运石之门  \n",
       "971               策划               设计               书法               摄影  \n",
       "972          无头骑士异闻录             灌篮高手           辛普森的一家             灌篮高手  \n",
       "973              钵钵鸡              卤肉饭               寿司              牛肉面  \n",
       "974             火影忍者            妖精的尾巴              七龙珠          喜羊羊和灰太狼  \n",
       "975            妖精的尾巴           中国惊奇先生            命运石之门            命运石之门  \n",
       "976              酸菜鱼               火锅              豆腐脑               火锅  \n",
       "977              迪斯尼             环太平洋             让子弹飞               漫威  \n",
       "978              豆腐脑              口水鸡              口水鸡             糖醋排骨  \n",
       "979            创造101          蒙面唱将猜猜猜            老梁故事汇             极限挑张  \n",
       "980              卤肉饭               寿司               烤肉               烤肉  \n",
       "981            真正男子汉            创造101          蒙面唱将猜猜猜            快乐大本营  \n",
       "982             迪丽热巴             新垣结衣              黄子韬             新垣结衣  \n",
       "983               火锅             三汁焖锅               火锅              口水鸡  \n",
       "984               摄影               花艺               绘画               写作  \n",
       "985               编程               摄影               策划               文案  \n",
       "986            中国好声音             天天向上             极限挑张             极限挑张  \n",
       "987              迪斯尼            复仇者联盟             让子弹飞              迪斯尼  \n",
       "988             非诚勿扰            老梁故事汇             天天向上            创造101  \n",
       "989              吴亦凡               鹿晗              周杰伦              赵丽颖  \n",
       "990          喜羊羊和灰太狼              七龙珠          无头骑士异闻录              海贼王  \n",
       "991             天天向上            演员的诞生              奔跑吧            热血街舞团  \n",
       "992               编程             电子音乐               料理               料理  \n",
       "993               档案            我们十七岁            老梁故事汇              奔跑吧  \n",
       "994             让子弹飞            缝纫机乐队            泰坦尼克号             一代宗师  \n",
       "995             美丽人生             让子弹飞             让子弹飞            春娇与志明  \n",
       "996            寻梦幻游记             霸王别姬              终结者              海豚湾  \n",
       "997           辛普森的一家           辛普森的一家            妖精的尾巴             火影忍者  \n",
       "998               文案               绘画             电子音乐               摄影  \n",
       "999            演员的诞生            中国好声音              奔跑吧             极限挑张  \n",
       "\n",
       "[1000 rows x 18 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data['year'] = 0\n",
    "user_data['year'] = user_data['year'].apply(lambda x : np.random.choice(range(2000,2018)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "user_data.to_csv('user_data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
